package com.ideal.manage.esms.repository.integration;


import com.ideal.manage.esms.bean.esms.EsmsIntegration;
import com.ideal.manage.esms.repository.framework.BaseRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.Date;
import java.util.List;

/**
 * @author Allen
 */
public interface IntegrationRepository extends BaseRepository<EsmsIntegration,String> {
    @Query("select i from EsmsIntegration i where i.projectIp=?1 and i.calTime>?2 and i.calTime<?3 order by i.calTime asc ")
    List<EsmsIntegration> findByDatas(String ip, Date startTime, Date endTime);
}
